RCG SAP S/4HANA Orders System API - Implementation Template

2.4.x
(0 reviews)

Data mappings

This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.

ModuleDescription
createOrdersRequest
getOrderByIdResponse
getOrderListResponse
updateOrdersRequest

createOrdersRequest

Source: ./src/main/resources/dwl/createOrdersRequest.dwl

Mapping Tables

Create Sales Order request mapping.

| SAP HANA Field | CIM Field | Description of source field
|
| :---- | :---- | :---- |
| SalesOrderType | salesOrderType | Sales Order Type
|
| SalesOrganization | salesChannel | Sales Order salesChannel
|
| DistributionChannel | salesChannel | Sales Channel Name
|
| OrganizationDivision | organizationDivision | Sales Order division
|
| SoldToParty | soldToCustomer | soldToCustomer Id
|
| PurchaseOrderByCustomer | purchaseOrderNumber | purchaseOrder Number
|
| TransactionCurrency | currency | currency details
|
| YY1_SME_MORDERID | externalIds.externalId | Master Order Id
|
| to_Item.NetAmount | totalLineAmount | Sales Order Net Amount
|
| to_Item.Material | orderProductNumber | Material Details
|
| to_Item.ItemWeightSAPUnit | "PC" | Sales Order unit details
|
| to_Item.TransactionCurrency | orderCurrency | Sales Order transaction currency
|
| to_Item.ProductionPlant | productionPlant | SAP HANA Production Plant |

(back to top)

getOrderByIdResponse

Source: ./src/main/resources/dwl/getOrderByIdResponse.dwl

Mapping Tables

Get Sales Order by ID response mapping.

Resp FieldSales Order Source fieldDescription of source field
nameSenderBusinessSystemNameSales Order Name
idSalesOrderSales Order Id
orderNumberSalesOrderSales Order Number
descriptionSalesOrderItemTextSales Order Description
grandTotalAmountTotalNetAmountSales Order Total Amount
billToContactShippingPointSales Order Bill Contact
priceCalculationStatusMessageTextSalesOrderItemTextSales Order Price Status
totalAdjustedDeliveryTaxAmountTotalAdjustedDeliveryAmountSales Order Adjusted Delivery Amount
renewalUpliftRateAccountingExchangeRateSales Order Renewal Up Lift Rate
salesOrderConfirmationStatusOverallTotalDeliveryStatusSales Order Delivery Status
salesChannel DistributionChannelSales Order Sales Channel
developerStatusCodeDeliveryStatusSales Order Delivery Status
billToAccountMatlAccountAssignmentGroupSales Order Bill Account
totalProductAmountNetAmountSales Order Product Amount
originalOrderSalesOrderSales Order Original Order
billToAddressShippingPointSales Order Address Bill
shipToContactShippingPointSales Order Shipping Point
totalDeliveryAmountTotalNetAmountSales Order Delivery Amount
salesOrderType.idSalesOrderTypeSales Order Id
salesOrderType.nameSalesGroupSales Order Sales Group
externalIds.externalIdType.idSalesOrderSales Order Id
externalIds.externalIdType.nameSenderBusinessSystemNameSales Order Name
externalIds.externalIdExternalItemIDSales Order External Id
externalIds.idSalesOrderSales Order Id
externalIds.statusLastChangedDateLastChangeDateTimeSales Order Status Last Changed DateTime
purchaseOrderNumberPurchaseOrderByCustomerSales Order Purchase Number

(back to top)

getOrderListResponse

Source: ./src/main/resources/dwl/getOrderListResponse.dwl

Mapping Tables

Get Sales Order List response mapping.

Resp FieldSales Order Source fieldDescription of source field
nameSenderBusinessSystemNameSales Order Name
idSalesOrderSales Order Id
orderNumberSalesOrderSales Order Number
descriptionSalesOrderItemTextSales Order Description
developerStatusCodeDeliveryStatusSales Order Delivery Status
salesOrderConfirmationStatus.idDeliveryStatusSales Order Status
salesOrderConfirmationStatus.nameOverallTotalDeliveryStatusSales Order Status
purchaseOrderNumberPurchaseOrderByCustomerSales Order Purchase Number
totalDeliveryAmountTotalNetAmountSales Order Delivery Amount
billToContactShippingPointSales Order Bill Contact
billToAccountMatlAccountAssignmentGroupSales Order Bill Account
shipToContactShippingPointSales Order Shipping Point
grandTotalAmountTotalNetAmountSales Order Total Amount
shipToAddressShippingAddressSales Order Shipping Address
salesChannel.idDistributionChannelSales Order Sales Channel
salesChannel.developerStatusCodeDeliveryStatusSales Order Delivery Status
originalOrderSalesOrderSales Order Original Order
billToAddressShippingPointSales Order Address Bill
salesOrderType.idSalesOrderTypeSales Order Id
salesOrderType.nameSalesGroupSales Order Sales Group
externalIds.externalIdType.idSalesOrderSales Order Id
externalIds.externalIdType.nameSenderBusinessSystemNameSales Order Name
externalIds.externalIdExternalItemIDSales Order External Id
externalIds.idSalesOrderSales Order Id
externalIds.statusLastChangedDateLastChangeDateTimeSales Order Status Last Changed DateTime
priceCalculationStatusMessageTextSalesOrderItemTextSales Order Price Status
renewalUpliftRateAccountingExchangeRateSales Order Renewal Up Lift Rate

(back to top)

updateOrdersRequest

Source: ./src/main/resources/dwl/updateOrdersRequest.dwl

Mapping Tables

Update Sales Order request mapping.

SAP HANA Order FieldCIM FieldDescription of source field
SalesOrderTypesalesOrderTypeSales Order Type
SalesOrderorderIdSales Order Number
SalesOrganizationsalesChannelSales Order salesChannel
SoldToPartysoldToCustomersoldToCustomer Id
PurchaseOrderByCustomerpurchaseOrderNumberpurchaseOrder Number
TotalNetAmounttotalProductAmountTotal net amount
TransactionCurrencycurrencycurrency details
ExternalDocumentIDexternalIds.externalIdExternal ID

(back to top)

Reviews

TypeTemplate
OrganizationMuleSoft
Published by
MuleSoft Solutions
Published onJan 31, 2024

Asset versions for 2.4.x

Version
2.4.4
2.4.3